UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k0XwSxF5fWCJTSblIIG04HY+iC51j0u8szJ0MdFB8UY='
WHERE
key_id = '39ab896c42dd12b1633e66caea2de0f1a568163ab52bde95f0487b33af2e6ff1'
AND (
token = 'k0XwSxF5fWCJTSblIIG04HY+iC51j0u8szJ0MdFB8UY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)