UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzlni13px31Jnf5ud3PD9Xyn3YT1FO8Lx4d7msN2dfU='
WHERE
key_id = '27967bea2925c0b65610ea64e0b4a2c585012f74967eca0d7633f7d92f6020d1'
AND (
token = 'mzlni13px31Jnf5ud3PD9Xyn3YT1FO8Lx4d7msN2dfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)