UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0YbDGYBSqibr25UzkjKtGGMPZHUxuYv5PPK0ie6fNEE='
WHERE
key_id = '27d98b3afa900a6fb706044e46416f25562a44eb934007917caa9e17fa787c7f'
AND (
token = '0YbDGYBSqibr25UzkjKtGGMPZHUxuYv5PPK0ie6fNEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)