UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SPFl65eUGUm20GknaYZasPB7Noeg/0HRjM7LaCYQ9g4='
WHERE
key_id = 'd165d2cbf9c54e1eb0665a3adcd772311f1f1a79122ee222620e5d49c1c93c11'
AND (
token = 'SPFl65eUGUm20GknaYZasPB7Noeg/0HRjM7LaCYQ9g4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)