UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0APE7TeHkYqWb7TZRtpnS9txv3R1i/X2SIiLZbqrZ0='
WHERE
key_id = '302705d3fda13784593f9b3c0461d9e6a3e1df791af329c298c0cf3b92173545'
AND (
token = 'a0APE7TeHkYqWb7TZRtpnS9txv3R1i/X2SIiLZbqrZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)