UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'karCoYg5TuSH5dDy22La8laj4Ztb3yZFemZ20cK7P9Y='
WHERE
key_id = '10ea0bd7cc5f1989bd77c30847c05c06fcaaa36ce80e7d5c8c374680832348c3'
AND (
token = 'karCoYg5TuSH5dDy22La8laj4Ztb3yZFemZ20cK7P9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)