UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wVUhjWKm6HzK36oVSanlRLbL/nyfMh8OvK7tn4nrGsU='
WHERE
key_id = 'edcd1ab0e43f47f3df262e86e8b8f2c0e00c3ab55d7811faada8003e729f7139'
AND (
token = 'wVUhjWKm6HzK36oVSanlRLbL/nyfMh8OvK7tn4nrGsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)