UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q/HEvL6+DvRWw0iHGEaSvzjx9LpsUUhFmDM3sSs/YZE='
WHERE
key_id = 'ecd7e149146235a1d6a8f14731816cbdeac5635571ad492f694e6997f196ff19'
AND (
token = 'Q/HEvL6+DvRWw0iHGEaSvzjx9LpsUUhFmDM3sSs/YZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)