UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsZ8n2akZwWnEEUuaGcviUJO0epvvBp+T4z/28jH9k8='
WHERE
key_id = 'a378b917f1f29a75d0c5257476e5efa08f39f4b3d7b3647495a6cb94c9e1a703'
AND (
token = 'ZsZ8n2akZwWnEEUuaGcviUJO0epvvBp+T4z/28jH9k8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)