UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9s7vJjvk1J3MmzTVR8eK0TVM9c77kYs4jKb12RlKZG4='
WHERE
key_id = 'b559e4757f3a2d9c9fffdc1b0fd10f3e0c07166c16e3fd44d8b64a4889bee22c'
AND (
token = '9s7vJjvk1J3MmzTVR8eK0TVM9c77kYs4jKb12RlKZG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)