UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i6zU3dVc1aYJ/pF5REVIZsNXV4GEalDycMOY/vq9k9k='
WHERE
key_id = '4ec9f8acfc10916301d3c1eb5b07c437bf68833526481d60359f9c0b54c8aa7d'
AND (
token = 'i6zU3dVc1aYJ/pF5REVIZsNXV4GEalDycMOY/vq9k9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)