UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HsRi8Zg6sRCQC3hzXJ7RB7CAuLrH86iHb64GGQdutQU='
WHERE
key_id = '93a9920e8fd5484f5ded1288a518cb242ee65004a752ae00b178990879fd3931'
AND (
token = 'HsRi8Zg6sRCQC3hzXJ7RB7CAuLrH86iHb64GGQdutQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)