UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4EiDIOHyrpYdwYetKSrqXCjtgNMUYKNo8sh8EkaofqE=' 
WHERE 
  key_id = 'b6162e0b04e0abda1bc8218ef1585de7b6a7c2fbaa5e8198aba0e2ddd299c126' 
  AND (
    token = '4EiDIOHyrpYdwYetKSrqXCjtgNMUYKNo8sh8EkaofqE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049