UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HhTnlNUlkmyPgf54Jr/mJPansNKDfP5DUo+umGLYKFU='
WHERE
key_id = 'dce210718aca4ace8bae684540c34e2d41f3af840174d0f683c1d8b71aa4d9ed'
AND (
token = 'HhTnlNUlkmyPgf54Jr/mJPansNKDfP5DUo+umGLYKFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)