UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cZGLMKMKJHInBM8HC7KptBV53Z+1s4WfoX9LGfMe1eM='
WHERE
key_id = 'a4553516ecea1600063061a529aaf10b88684a0727190b84d5bcb782cf6c946b'
AND (
token = 'cZGLMKMKJHInBM8HC7KptBV53Z+1s4WfoX9LGfMe1eM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)