UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xl9o9gJ8Jq4e1wFkT+Zn530td/A9b+U9Rj993htURyk='
WHERE
key_id = '986a8437b40a66a9fc96c237c121c1204a51facd6e10151223f4c749940418f4'
AND (
token = 'Xl9o9gJ8Jq4e1wFkT+Zn530td/A9b+U9Rj993htURyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)