UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/EcAO2kK5ktNh9gG1EXU8GsUmO4MR0NWWIBFvG4WOSs=' 
WHERE 
  key_id = '39e23c3d276ff056fe3f0fdc035e95fc1164c6844f644e7148ff0013409da7c3' 
  AND (
    token = '/EcAO2kK5ktNh9gG1EXU8GsUmO4MR0NWWIBFvG4WOSs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039