UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y+836Ch17qKcpIRMvwb9AaLNMKw1BsWGS9ox1k5WlZU='
WHERE
key_id = 'b1f6419e70412c4ac506b1976a4dda7c3597c58d7f89a6a0229183b3cb36b33c'
AND (
token = 'Y+836Ch17qKcpIRMvwb9AaLNMKw1BsWGS9ox1k5WlZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)