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