UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J768FazwtFhkobFufJvuhk6HE8uKVZkdrVfqJO1j2TU='
WHERE
key_id = '1c2e5fc5710b92d05d86951cec20bef353995f1f31bae74b6d9fde7f1e65157a'
AND (
token = 'J768FazwtFhkobFufJvuhk6HE8uKVZkdrVfqJO1j2TU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)