UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OObHuEhTm33kJLFzJIWQ8LUddX2vypWL7v5xXm3McPw='
WHERE
key_id = '3e400fa4336337da4f162f3fded91b784ed10f3365a673e6be3648ae3124e705'
AND (
token = 'OObHuEhTm33kJLFzJIWQ8LUddX2vypWL7v5xXm3McPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)