UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qO7ZEO7ljoZDdoWvhT945QSaTeQH00hIKzGfuhUFPpA='
WHERE
key_id = '286ae5ba93244804a64c483651bf838b2761e7e299766c145b079ae15647bb1d'
AND (
token = 'qO7ZEO7ljoZDdoWvhT945QSaTeQH00hIKzGfuhUFPpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)