UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tIYswyL5mxgiGNMbj5CHPWqN4X7S+t4yY+8025kTRk='
WHERE
key_id = '1c746f6bf8a28517e294b24dd349ff7865e37f447f22840b7e4f34170c32a673'
AND (
token = '8tIYswyL5mxgiGNMbj5CHPWqN4X7S+t4yY+8025kTRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)