UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xz5AkPy9gRU/57mP/wG1shICxtL6r1XvkMh2pS7qk+w='
WHERE
key_id = 'fc74c67a2267a9a46ad318f54b91eb64718de03b69ecf3424d48a586de8b09de'
AND (
token = 'xz5AkPy9gRU/57mP/wG1shICxtL6r1XvkMh2pS7qk+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)