UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4YtmHUPs1tduXAl7Qy3sqnIStylkzBuCdBg50MtgyIA='
WHERE
key_id = '12d65f08101cbbc3b3b4ff61ac7f47d5974bf85abeb21436114b060f7785433d'
AND (
token = '4YtmHUPs1tduXAl7Qy3sqnIStylkzBuCdBg50MtgyIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)