UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hdtQY7ZD6vSJysh4FjjQ5D1nDiDp5hmGf1YZb1sOkIY='
WHERE
key_id = 'e966f068eeef74e79c4ed3f6aa4adb7b8131bef4a80e5f32adaad8fd3d0889ef'
AND (
token = 'hdtQY7ZD6vSJysh4FjjQ5D1nDiDp5hmGf1YZb1sOkIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)