UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8aU+pmTe3mM5gKuNIPL6ihLBqKsaRveK70lUWRXgxE='
WHERE
key_id = 'e729101a5b2a1efd8352a2c6cd00094cb9062a3591cf39ddc0c217c54337588e'
AND (
token = 'q8aU+pmTe3mM5gKuNIPL6ihLBqKsaRveK70lUWRXgxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)