UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eUMaXHZ24ma/yKYtmisUspkRmFJlbl04awze/iyG5VU='
WHERE
key_id = '67ae47657b9dbf1f357ecc00f3a16af5cbfc3029827afc70517666efc5cf3ea0'
AND (
token = 'eUMaXHZ24ma/yKYtmisUspkRmFJlbl04awze/iyG5VU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)