UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/dATC1whrIPAMBPDX7C3H5+3i5Wmyvi8YdaQnO89kaU=' 
WHERE 
  key_id = '92c2d5e9d859cde71b02b0af3d8ed14cf0a8e257c38d53e8dc174f8d69ecac1e' 
  AND (
    token = '/dATC1whrIPAMBPDX7C3H5+3i5Wmyvi8YdaQnO89kaU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025