UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3jUgZHORhOQ5tZW+nvo179GG1BmpmPGrIKrzIAyfa1U=' 
WHERE 
  key_id = '066ef7d546d45026a9c7f4bb32b419fa2e80ac56b34d60e920f331d80d19c91a' 
  AND (
    token = '3jUgZHORhOQ5tZW+nvo179GG1BmpmPGrIKrzIAyfa1U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033