UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9TQ8I855y7xnQ4jHRgPuRzKkj9hUs0TR+dd0hIPvy7Q='
WHERE
key_id = '0d16223f60d5b5447c4899ac66500973bd39fe39ce64863d45d9160de4bed3de'
AND (
token = '9TQ8I855y7xnQ4jHRgPuRzKkj9hUs0TR+dd0hIPvy7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)