UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pkZWJZXMvDJ1ltS82y5vUaCEbB0KuBI+a1qKMPzwj5U='
WHERE
key_id = 'db131a8a371563a0b64837a6bcd7b958f46a2f65047918f0f2a255b4fe6acd1f'
AND (
token = 'pkZWJZXMvDJ1ltS82y5vUaCEbB0KuBI+a1qKMPzwj5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)